package com.intelligent.mapper;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.intelligent.pojo.ProductionReporting;
import org.apache.ibatis.annotations.Param;

import java.util.Map;

/**
* @author lenovo
* @description 针对表【production_reporting(生产报工表)】的数据库操作Mapper
* @createDate 2025-09-05 09:15:29
* @Entity com.intelligent.pojo.ProductionReporting
*/
public interface ProductionReportingMapper extends BaseMapper<ProductionReporting> {

    IPage<Map<String, Object>> selectPageWithJoin(
            Page<Map<String, Object>> page,
            @Param("reportNo") String reportNo,
            @Param("processName") String processName,
            @Param("processCode") String processCode,
            @Param("relatedWorkOrder") String relatedWorkOrder,
            @Param("username") String username,
            @Param("workGroup") String workGroup,
            @Param("qcStatus") Integer qcStatus,
            @Param("startDate") String startDate,
            @Param("endDate") String endDate
    );

    Map<String, Object> selectDetailById(@Param("id") Long id);

    int insertProductionReporting(ProductionReporting productionReporting);

    int updateProductionReporting(ProductionReporting productionReporting);

    int deleteByIdCustom(@Param("id") Long id);

}




